package com.bric.sqlFile;

import java.sql.Connection;
import java.sql.PreparedStatement;

import org.apache.log4j.Logger;

import com.bric.util.JdbcFactory;

public class UpdateUploadPrice extends Thread{
	private static final Logger log=Logger.getLogger(UpdateUploadPrice.class);
	@Override
	public void run() {
		Connection conn=null;
		PreparedStatement ps=null;
		try {
			conn=JdbcFactory.getConnection();
			ps=conn.prepareStatement("update accfutures.upload set price='0'");
			ps.executeUpdate();
			log.info("更新报告价格成功...");
		}catch(Exception e){
			log.info("更新报告价格出现异常");
		}finally{
			JdbcFactory.close(conn, ps);
		}
	}
}
